const main = {
  add: `INSERT INTO UserAccount
    (id, tel, pswd, openid, cardid) VALUES
    (?, ?, ?, ?, ?)`,
  update: `UPDATE UserAccount SET
    pswd = ? WHERE id = ?`,
  
  selectForLogin: `SELECT * FROM UserAccount
    WHERE tel = ? OR openid = ?`,
  selectForRegisterCheck: `SELECT COUNT(*) AS total FROM UserAccount WHERE tel = ?`
};

module.exports = main;